
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspSiteUserExtended_UPDATE]
(
@userId int = null,
@firstName nvarchar(50) = null,
@middleName nvarchar(50) = null,
@lastName nvarchar(50) = null,
@jobId int = null,
@jobPosition nvarchar(200) = null,
@birthDate datetime = null,
@phone1 nvarchar(100) = null,
@phone2 nvarchar(100) = null,
@icq nvarchar(15) = null,
@skype nvarchar(100) = null
)
AS

UPDATE
  [dbo].[SiteUserExtended]
SET
  [UserId] = @userId,
  [FirstName] = @firstName,
  [MiddleName] = @middleName,
  [LastName] = @lastName,
  [JobId] = @jobId,
  [JobPosition] = @jobPosition,
  [BirthDate] = @birthDate,
  [Phone1] = @phone1,
  [Phone2] = @phone2,
  [ICQ] = @icq,
  [Skype] = @skype
WHERE
  [UserId] = @userId

GO
